Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_CHANGE_NOTIFICATION_REGS

`DBA_CHANGE_NOTIFICATION_REGS` describes all change notification registrations for the database.

Related View

`USER_CHANGE_NOTIFICATION_REGS` describes change notification registrations for current user. This view does not display the `USERNAME` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`USERNAME` | `VARCHAR2(31)` |  | Owner of the registration
`REGID` | `NUMBER` |  | Internal registration ID
`REGFLAGS` | `NUMBER` |  | Registration flags
`CALLBACK` | `VARCHAR2(63)` |  | Notification callback
`OPERATIONS_FILTER` | `NUMBER` |  | Operations filter (if specified)
`CHANGELAG` | `NUMBER` |  | Transaction lag between notifications (if specified)
`TIMEOUT` | `NUMBER` |  | Registration timeout (if specified)
`TABLE_NAME` | `VARCHAR2(63)` |  | Name of registered table